package boogui.member;

public class MemberSQL {

	// 회원 가입
	private String insertMemberSQL = "insert into member values(movie.nextval, ?, ?, ?, to_date(?, 'YYYYMMDD'), ?, ?, ?)";
	// 회원 정보 조회 (전체)
	private String selectMemberSQL = "select * from member order by memno desc";
	// 회원 탈퇴
	private String deleteMemberSQL = "delete MEMBER  where memno = ?";
	// 회원 정보 수정
	private String updateMemberSQL = "update member set mempwd = ?,memname = ?, membirth = to_date(?, 'YYYYMMDD'),memgenre =?, memhp = ?, mememail=? where memid = ?";
	// 비밀번호 불러오기
	private String selectPwdSQL = "select mempwd from member where memid = ?";
	// 아이디 중복 검사
	private String chkIdSQL = "select * from member where memid = ?";
	// 핸드폰 중복 검사
	private String chkHpSQL = "select * from member where memhp = ?";
	// 이메일 중복 검사
	private String chkEmailSQL = "select * from member where mememail = ?";
	// 아이디 찾기
	private String findIdSQL = "select * from member where memname = ? and mememail = ?";
	// 비밀번호 찾기
	private String findPwdSQL = "select * from member where memid = ? and memname = ? and mememail = ?";
	// 비밀번호 변경
	private String changePwdSQL = "update member set mempwd = ? where memid = ?";
	// 로그인 아이디 입력(로그인상태 알기위함)
	private String loginSQL = "update logininfo set memno = (select memno from member where memid = ?)";
	// 로그인한 아이디의 이름
	private String loginViewSQL = "select memid,memname,membirth,memgenre,memhp,mememail from member m inner join logininfo l on m.memno = l.memno";
	private String SDateSQL="select sdate from showing";
	
	
	public String getSDateSQL(){
		return SDateSQL;
	}
	public void setSDateSQL(String SDateSQL){
		this.SDateSQL = SDateSQL;
	}
	
	public String getLoginViewSQL() {
		return loginViewSQL;
	}
	public void setLoginViewSQL(String loginViewSQL) {
		this.loginViewSQL = loginViewSQL;
	}
	public String getLoginSQL() {
		return loginSQL;
	}
	public void setLoginSQL(String loginSQL) {
		this.loginSQL = loginSQL;
	}
	public String getInsertMemberSQL() {
		return insertMemberSQL;
	}
	public void setInsertMemberSQL(String insertMemberSQL) {
		this.insertMemberSQL = insertMemberSQL;
	}
	public String getSelectMemberSQL() {
		return selectMemberSQL;
	}
	public void setSelectMemberSQL(String selectMemberSQL) {
		this.selectMemberSQL = selectMemberSQL;
	}
	public String getDeleteMemberSQL() {
		return deleteMemberSQL;
	}
	public void setDeleteMemberSQL(String deleteMemberSQL) {
		this.deleteMemberSQL = deleteMemberSQL;
	}
	public String getUpdateMemberSQL() {
		return updateMemberSQL;
	}
	public void setUpdateMemberSQL(String updateMemberSQL) {
		this.updateMemberSQL = updateMemberSQL;
	}
	public String getSelectPwdSQL() {
		return selectPwdSQL;
	}
	public void setSelectPwdSQL(String selectPwdSQL) {
		this.selectPwdSQL = selectPwdSQL;
	}
	public String getChkIdSQL() {
		return chkIdSQL;
	}
	public void setChkIdSQL(String chkIdSQL) {
		this.chkIdSQL = chkIdSQL;
	}
	public String getChkHpSQL() {
		return chkHpSQL;
	}
	public void setChkHpSQL(String chkHpSQL) {
		this.chkHpSQL = chkHpSQL;
	}
	public String getChkEmailSQL() {
		return chkEmailSQL;
	}
	public void setChkEmailSQL(String chkEmailSQL) {
		this.chkEmailSQL = chkEmailSQL;
	}
	public String getFindIdSQL() {
		return findIdSQL;
	}
	public void setFindIdSQL(String findIdSQL) {
		this.findIdSQL = findIdSQL;
	}
	public String getFindPwdSQL() {
		return findPwdSQL;
	}
	public void setFindPwdSQL(String findPwdSQL) {
		this.findPwdSQL = findPwdSQL;
	}
	public String getChangePwdSQL() {
		return changePwdSQL;
	}
	public void setChangePwdSQL(String changePwdSQL) {
		this.changePwdSQL = changePwdSQL;
	}
  
}
